Asset data profiling report

Dataset statistics

Number of variables	44
Number of observations	198
Missing cells	3197
Missing cells (%)	36.7%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	68.2 KiB
Average record size in memory	352.6 B

Variable types

CAT	21
NUM	12
DATE	4
UNSUPPORTED	4
BOOL	3

Warnings

`Select project` has constant value "198"	Constant
`FR1_ProjectName` has constant value "198"	Constant
`FR3 Area Units` has constant value "198"	Constant
`Asset ID:` has a high cardinality: 194 distinct values	High cardinality
`Asset Description` has a high cardinality: 195 distinct values	High cardinality
`Comments` has a high cardinality: 79 distinct values	High cardinality
`Bund height (m)` is highly correlated with `ObjectID` and 4 other fields	High correlation
`ObjectID` is highly correlated with `Bund height (m)` and 1 other fields	High correlation
`Bund width (m)` is highly correlated with `Installed Cost (£)` and 1 other fields	High correlation
`Installed Cost (£)` is highly correlated with `Bund width (m)`	High correlation
`Bund length (m)` is highly correlated with `ObjectID` and 3 other fields	High correlation
`Storage Created (m3)` is highly correlated with `Bund width (m)` and 1 other fields	High correlation
`FR3_AreaRough` is highly correlated with `Storage Created (m3)`	High correlation
`longitude` is highly correlated with `Bund height (m)` and 1 other fields	High correlation
`latitude` is highly correlated with `Bund height (m)` and 1 other fields	High correlation
`log10_price` is highly correlated with `Bund height (m)`	High correlation
`Watercourse Type` has 5 (2.5%) missing values	Missing
`Stream Width (m)` has 42 (21.2%) missing values	Missing
`Land Drainage Consent Difficulty` has 10 (5.1%) missing values	Missing
`Ecological Consent Difficulty` has 13 (6.6%) missing values	Missing
`Average member length in Leaky Barrier (m)` has 41 (20.7%) missing values	Missing
`Wood Diameter (cm)` has 66 (33.3%) missing values	Missing
`Height of Leaky Barrier above bed (cm)` has 44 (22.2%) missing values	Missing
`Height of Leaky Barrier above bank (cm)` has 115 (58.1%) missing values	Missing
`Wood Species Used` has 170 (85.9%) missing values	Missing
`Other Wood Species` has 190 (96.0%) missing values	Missing
`Bund height (m)` has 194 (98.0%) missing values	Missing
`Bund width (m)` has 194 (98.0%) missing values	Missing
`Bund length (m)` has 194 (98.0%) missing values	Missing
`Bund Material` has 189 (95.5%) missing values	Missing
`Gully Block Length (m)` has 198 (100.0%) missing values	Missing
`Gully Block Width (m)` has 198 (100.0%) missing values	Missing
`Gully Block Material` has 198 (100.0%) missing values	Missing
`Soil Equipment or Technique Used` has 198 (100.0%) missing values	Missing
`Flood Efficacy` has 37 (18.7%) missing values	Missing
`FR3_AreaRough` has 190 (96.0%) missing values	Missing
`Storage Created (m3)` has 3 (1.5%) missing values	Missing
`FR3_AreaIncreasedLoss` has 195 (98.5%) missing values	Missing
`Changed Flood Pathway?` has 66 (33.3%) missing values	Missing
`Reduced Erosion?` has 155 (78.3%) missing values	Missing
`Asset Condition` has 13 (6.6%) missing values	Missing
`Date Assessed` has 11 (5.6%) missing values	Missing
`Comments` has 84 (42.4%) missing values	Missing
`Creator` has 172 (86.9%) missing values	Missing
`Editor` has 12 (6.1%) missing values	Missing
`Asset ID:` is uniformly distributed	Uniform
`Asset Description` is uniformly distributed	Uniform
`ObjectID` has unique values	Unique
`GlobalID` has unique values	Unique
`CreationDate` has unique values	Unique
`longitude` has unique values	Unique
`latitude` has unique values	Unique
`Gully Block Length (m)` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Gully Block Width (m)` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Gully Block Material` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Soil Equipment or Technique Used` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Installed Cost (£)` has 3 (1.5%) zeros	Zeros
`Height of Leaky Barrier above bed (cm)` has 3 (1.5%) zeros	Zeros
`Height of Leaky Barrier above bank (cm)` has 42 (21.2%) zeros	Zeros
`FR3_AreaRough` has 3 (1.5%) zeros	Zeros
`Storage Created (m3)` has 2 (1.0%) zeros	Zeros

Reproduction

Analysis started	2020-10-13 23:17:27.362610
Analysis finished	2020-10-13 23:18:15.679643
Duration	48.32 seconds
Software version	pandas-profiling v2.9.0
Download configuration	config.yaml

ObjectID
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	198
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	677.5050505
Minimum	42
Maximum	1254
Zeros	0
Zeros (%)	0.0%
Memory size	1.5 KiB

Quantile statistics

Minimum	42
5-th percentile	289.85
Q1	454.25
median	650.5
Q3	718.75
95-th percentile	1211
Maximum	1254
Range	1212
Interquartile range (IQR)	264.5

Descriptive statistics

Standard deviation	292.2571663
Coefficient of variation (CV)	0.4313726755
Kurtosis	-0.4231717337
Mean	677.5050505
Median Absolute Deviation (MAD)	190
Skewness	0.4629322464
Sum	134146
Variance	85414.25124
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1122	1	0.5%
674	1	0.5%
670	1	0.5%
669	1	0.5%
668	1	0.5%
667	1	0.5%
666	1	0.5%
665	1	0.5%
664	1	0.5%
619	1	0.5%
Other values (188)	188	94.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
42	1	0.5%
90	1	0.5%
91	1	0.5%
92	1	0.5%
93	1	0.5%

Value	Count	Frequency (%)
1254	1	0.5%
1253	1	0.5%
1252	1	0.5%
1251	1	0.5%
1250	1	0.5%

GlobalID
Categorical

UNIQUE

Distinct	198
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	1.5 KiB

cbf127d8-106a-4d9d-949c-473b3078ad42	1
6f0e9956-8d95-4ebf-a540-9f0cabc735e9	1
945b0df9-3996-4d09-8b0f-b0ab40ae8198	1
c53075f1-4e5b-4885-b250-feecdaa6493e	1
d29a1053-7fe8-4a50-9403-74ccbd4e45fb	1
Other values (193)	193

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
cbf127d8-106a-4d9d-949c-473b3078ad42	1	0.5%
6f0e9956-8d95-4ebf-a540-9f0cabc735e9	1	0.5%
945b0df9-3996-4d09-8b0f-b0ab40ae8198	1	0.5%
c53075f1-4e5b-4885-b250-feecdaa6493e	1	0.5%
d29a1053-7fe8-4a50-9403-74ccbd4e45fb	1	0.5%
1d32eb4f-29cb-4dd9-8e9c-4d94d643dc02	1	0.5%
28d45f34-03aa-425c-a28a-ede44093cc79	1	0.5%
ec128f1e-7bdb-433c-8566-70459f0584a3	1	0.5%
aae98524-b3a9-4337-8ff5-88ed44dc2b31	1	0.5%
6bb19f39-da8c-4e6a-95d4-d202ba6611ad	1	0.5%
Other values (188)	188	94.9%

Frequencies of value counts

Unique

Unique	198 ?
Unique (%)	100.0%

Histogram of lengths of the category

Length

Max length	36
Median length	36
Mean length	36
Min length	36

Select project
Categorical

CONSTANT
REJECTED

Distinct	1
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	1.5 KiB

A017	198

Frequencies
Length

Value	Count	Frequency (%)
A017	198	100.0%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	4
Median length	4
Mean length	4
Min length	4

FR1_ProjectName
Categorical

CONSTANT
REJECTED

Distinct	1
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	1.5 KiB

Shipston	198

Frequencies
Length

Value	Count	Frequency (%)
Shipston	198	100.0%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Asset ID:
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	194
Distinct (%)	98.0%
Missing	0
Missing (%)	0.0%
Memory size	1.5 KiB

A017_2002131359	2
A017_2005041404	2
A017_2003021344	2
A017_2004271037	2
A017_2005131053	1
Other values (189)	189

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
A017_2002131359	2	1.0%
A017_2005041404	2	1.0%
A017_2003021344	2	1.0%
A017_2004271037	2	1.0%
A017_2005131053	1	0.5%
A017_1912312004	1	0.5%
A017_2008151115	1	0.5%
A017_2002131410	1	0.5%
A017_2010071449	1	0.5%
A017_2004271022	1	0.5%
Other values (184)	184	92.9%

Frequencies of value counts

Unique

Unique	190 ?
Unique (%)	96.0%

Histogram of lengths of the category

Length

Max length	15
Median length	15
Mean length	15
Min length	15

Asset Type
Categorical

Distinct	6
Distinct (%)	3.0%
Missing	0
Missing (%)	0.0%
Memory size	1.5 KiB

leaky_barriers	165
offline_storage_areas	18
runoff_pathway_management	12
riparian_woodland_creation	1
river_restoration	1

Frequencies
Length

Value	Count	Frequency (%)
leaky_barriers	165	83.3%
offline_storage_areas	18	9.1%
runoff_pathway_management	12	6.1%
riparian_woodland_creation	1	0.5%
river_restoration	1	0.5%
cross_slope_woodland_creation	1	0.5%

Frequencies of value counts

Unique

Unique	3 ?
Unique (%)	1.5%

Histogram of lengths of the category

Length

Max length	29
Median length	14
Mean length	15.45454545
Min length	14

Asset Description
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	195
Distinct (%)	98.5%
Missing	0
Missing (%)	0.0%
Memory size	1.5 KiB

DELETE	4
KNEEBATS08LB5	1
KNEECOMP04LB3	1
KNEEBEECH02LB1	1
KNEELONG51LB51	1
Other values (190)	190

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
DELETE	4	2.0%
KNEEBATS08LB5	1	0.5%
KNEECOMP04LB3	1	0.5%
KNEEBEECH02LB1	1	0.5%
KNEELONG51LB51	1	0.5%
KNEELONG07LB7	1	0.5%
KNEELONG36LB36	1	0.5%
KNEELONG37LB37	1	0.5%
KNEELONG22LB22	1	0.5%
Hen1	1	0.5%
Other values (185)	185	93.4%

Frequencies of value counts

Unique

Unique	194 ?
Unique (%)	98.0%

Histogram of lengths of the category

Length

Max length	15
Median length	13
Mean length	12.52020202
Min length	1

Date Installed
Date

Distinct	48
Distinct (%)	24.2%
Missing	0
Missing (%)	0.0%
Memory size	1.5 KiB

Minimum	2017-05-31 12:00:00
Maximum	2020-10-07 11:00:00

Histogram

Histogram with fixed size bins (bins=48)

Installed Cost (£)
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	25
Distinct (%)	12.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	283.2828283
Minimum	0
Maximum	6000
Zeros	3
Zeros (%)	1.5%
Memory size	1.5 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	100
median	100
Q3	150
95-th percentile	1560
Maximum	6000
Range	6000
Interquartile range (IQR)	50

Descriptive statistics

Standard deviation	697.2500231
Coefficient of variation (CV)	2.461321173
Kurtosis	30.48896583
Mean	283.2828283
Median Absolute Deviation (MAD)	50
Skewness	5.060124046
Sum	56090
Variance	486157.5947
Monotocity	Not monotonic

Histogram with fixed size bins (bins=25)

Value	Count	Frequency (%)
100	65	32.8%
1	30	15.2%
150	23	11.6%
120	22	11.1%
60	10	5.1%
230	9	4.5%
160	7	3.5%
260	5	2.5%
200	5	2.5%
0	3	1.5%
Other values (15)	19	9.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	3	1.5%
1	30	15.2%
60	10	5.1%
100	65	32.8%
120	22	11.1%

Value	Count	Frequency (%)
6000	1	0.5%
4000	1	0.5%
3800	1	0.5%
2670	1	0.5%
2155	2	1.0%

Watercourse Type
Categorical

MISSING

Distinct	1
Distinct (%)	0.5%
Missing	5
Missing (%)	2.5%
Memory size	1.5 KiB

ordinary	193

Frequencies
Length

Value	Count	Frequency (%)
ordinary	193	97.5%
(Missing)	5	2.5%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	8
Median length	8
Mean length	7.873737374
Min length	3

Stream Width (m)
Real number (ℝ_≥0)

MISSING

Distinct	12
Distinct (%)	7.7%
Missing	42
Missing (%)	21.2%
Infinite	0
Infinite (%)	0.0%

Mean	1.510897436
Minimum	0.5
Maximum	38
Zeros	0
Zeros (%)	0.0%
Memory size	1.5 KiB

Quantile statistics

Minimum	0.5
5-th percentile	0.6
Q1	1
median	1
Q3	1.5
95-th percentile	2
Maximum	38
Range	37.5
Interquartile range (IQR)	0.5

Descriptive statistics

Standard deviation	2.985736495
Coefficient of variation (CV)	1.976134464
Kurtosis	146.5455001
Mean	1.510897436
Median Absolute Deviation (MAD)	0.25
Skewness	11.93046713
Sum	235.7
Variance	8.914622415
Monotocity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
1	71	35.9%
1.5	39	19.7%
2	20	10.1%
0.75	8	4.0%
0.5	6	3.0%
0.6	3	1.5%
3	3	1.5%
1.25	2	1.0%
1.2	1	0.5%
0.7	1	0.5%
Other values (2)	2	1.0%
(Missing)	42	21.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.5	6	3.0%
0.6	3	1.5%
0.7	1	0.5%
0.75	8	4.0%
1	71	35.9%

Value	Count	Frequency (%)
38	1	0.5%
4	1	0.5%
3	3	1.5%
2	20	10.1%
1.5	39	19.7%

Land Drainage Consent Difficulty
Categorical

MISSING

Distinct	3
Distinct (%)	1.6%
Missing	10
Missing (%)	5.1%
Memory size	1.5 KiB

easy	174
moderate	11
n_a	3

Frequencies
Length

Value	Count	Frequency (%)
easy	174	87.9%
moderate	11	5.6%
n_a	3	1.5%
(Missing)	10	5.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	8
Median length	4
Mean length	4.156565657
Min length	3

Ecological Consent Difficulty
Categorical

MISSING

Distinct	3
Distinct (%)	1.6%
Missing	13
Missing (%)	6.6%
Memory size	1.5 KiB

n_a	173
easy	11
moderate	1

Frequencies
Length

Value	Count	Frequency (%)
n_a	173	87.4%
easy	11	5.6%
moderate	1	0.5%
(Missing)	13	6.6%

Frequencies of value counts

Unique

Unique	1 ?
Unique (%)	0.5%

Histogram of lengths of the category

Length

Max length	8
Median length	3
Mean length	3.080808081
Min length	3

Average member length in Leaky Barrier (m)
Real number (ℝ_≥0)

MISSING

Distinct	12
Distinct (%)	7.6%
Missing	41
Missing (%)	20.7%
Infinite	0
Infinite (%)	0.0%

Mean	3.573248408
Minimum	1.5
Maximum	15
Zeros	0
Zeros (%)	0.0%
Memory size	1.5 KiB

Quantile statistics

Minimum	1.5
5-th percentile	2
Q1	2.5
median	3
Q3	4
95-th percentile	8
Maximum	15
Range	13.5
Interquartile range (IQR)	1.5

Descriptive statistics

Standard deviation	1.843052866
Coefficient of variation (CV)	0.5157919786
Kurtosis	10.43237514
Mean	3.573248408
Median Absolute Deviation (MAD)	1
Skewness	2.63726579
Sum	561
Variance	3.396843867
Monotocity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
3	44	22.2%
2	28	14.1%
2.5	23	11.6%
4	22	11.1%
5	11	5.6%
6	9	4.5%
3.5	8	4.0%
8	6	3.0%
1.5	2	1.0%
10	2	1.0%
Other values (2)	2	1.0%
(Missing)	41	20.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1.5	2	1.0%
2	28	14.1%
2.5	23	11.6%
3	44	22.2%
3.5	8	4.0%

Value	Count	Frequency (%)
15	1	0.5%
10	2	1.0%
8	6	3.0%
6	9	4.5%
5	11	5.6%

Wood Diameter (cm)
Real number (ℝ_≥0)

MISSING

Distinct	13
Distinct (%)	9.8%
Missing	66
Missing (%)	33.3%
Infinite	0
Infinite (%)	0.0%

Mean	21.57575758
Minimum	1
Maximum	100
Zeros	0
Zeros (%)	0.0%
Memory size	1.5 KiB

Quantile statistics

Minimum	1
5-th percentile	10
Q1	15
median	20
Q3	25
95-th percentile	34.5
Maximum	100
Range	99
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	11.07219281
Coefficient of variation (CV)	0.5131774757
Kurtosis	19.258222
Mean	21.57575758
Median Absolute Deviation (MAD)	5
Skewness	3.197978006
Sum	2848
Variance	122.5934536
Monotocity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
15	34	17.2%
25	27	13.6%
20	26	13.1%
30	20	10.1%
10	14	7.1%
40	3	1.5%
7.5	2	1.0%
60	1	0.5%
1	1	0.5%
50	1	0.5%
Other values (3)	3	1.5%
(Missing)	66	33.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1	0.5%
7.5	2	1.0%
10	14	7.1%
12	1	0.5%
15	34	17.2%

Value	Count	Frequency (%)
100	1	0.5%
60	1	0.5%
50	1	0.5%
45	1	0.5%
40	3	1.5%

Height of Leaky Barrier above bed (cm)
Real number (ℝ_≥0)

MISSING
ZEROS

Distinct	18
Distinct (%)	11.7%
Missing	44
Missing (%)	22.2%
Infinite	0
Infinite (%)	0.0%

Mean	26.7012987
Minimum	0
Maximum	200
Zeros	3
Zeros (%)	1.5%
Memory size	1.5 KiB

Quantile statistics

Minimum	0
5-th percentile	5
Q1	15
median	20
Q3	30
95-th percentile	60
Maximum	200
Range	200
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	24.68967657
Coefficient of variation (CV)	0.9246620115
Kurtosis	19.58612368
Mean	26.7012987
Median Absolute Deviation (MAD)	7.5
Skewness	3.681385316
Sum	4112
Variance	609.580129
Monotocity	Not monotonic

Histogram with fixed size bins (bins=18)

Value	Count	Frequency (%)
15	49	24.7%
30	21	10.6%
20	15	7.6%
25	13	6.6%
10	12	6.1%
60	9	4.5%
45	7	3.5%
40	7	3.5%
35	4	2.0%
100	3	1.5%
Other values (8)	14	7.1%
(Missing)	44	22.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	3	1.5%
1	3	1.5%
1.5	1	0.5%
5	3	1.5%
7.5	1	0.5%

Value	Count	Frequency (%)
200	1	0.5%
150	1	0.5%
100	3	1.5%
60	9	4.5%
50	1	0.5%

Height of Leaky Barrier above bank (cm)
Real number (ℝ_≥0)

MISSING
ZEROS

Distinct	16
Distinct (%)	19.3%
Missing	115
Missing (%)	58.1%
Infinite	0
Infinite (%)	0.0%

Mean	35.01686747
Minimum	0
Maximum	1050
Zeros	42
Zeros (%)	21.2%
Memory size	1.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	30
95-th percentile	100
Maximum	1050
Range	1050
Interquartile range (IQR)	30

Descriptive statistics

Standard deviation	118.7153521
Coefficient of variation (CV)	3.390233357
Kurtosis	67.06044716
Mean	35.01686747
Median Absolute Deviation (MAD)	0
Skewness	7.846383132
Sum	2906.4
Variance	14093.33483
Monotocity	Not monotonic

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
0	42	21.2%
15	8	4.0%
100	7	3.5%
50	6	3.0%
20	5	2.5%
30	4	2.0%
45	2	1.0%
110	1	0.5%
25	1	0.5%
5	1	0.5%
Other values (6)	6	3.0%
(Missing)	115	58.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	42	21.2%
0.2	1	0.5%
1.2	1	0.5%
5	1	0.5%
10	1	0.5%

Value	Count	Frequency (%)
1050	1	0.5%
200	1	0.5%
110	1	0.5%
100	7	3.5%
75	1	0.5%

Wood Species Used
Categorical

MISSING

Distinct	4
Distinct (%)	14.3%
Missing	170
Missing (%)	85.9%
Memory size	1.5 KiB

willow_dead	18
other	8
softwood	1
willow_live	1

Frequencies
Length

Value	Count	Frequency (%)
willow_dead	18	9.1%
other	8	4.0%
softwood	1	0.5%
willow_live	1	0.5%
(Missing)	170	85.9%

Frequencies of value counts

Unique

Unique	2 ?
Unique (%)	7.1%

Histogram of lengths of the category

Length

Max length	11
Median length	3
Mean length	3.873737374
Min length	3

Other Wood Species
Categorical

MISSING

Distinct	2
Distinct (%)	25.0%
Missing	190
Missing (%)	96.0%
Memory size	1.5 KiB

Leylandi	6
Machined	2

Frequencies
Length

Value	Count	Frequency (%)
Leylandi	6	3.0%
Machined	2	1.0%
(Missing)	190	96.0%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	8
Median length	3
Mean length	3.202020202
Min length	3

Bund height (m)
Categorical

HIGH CORRELATION
MISSING

Distinct	3
Distinct (%)	75.0%
Missing	194
Missing (%)	98.0%
Memory size	1.5 KiB

2	2
0.6	1
2.5	1

Frequencies
Length

Value	Count	Frequency (%)
2	2	1.0%
0.6	1	0.5%
2.5	1	0.5%
(Missing)	194	98.0%

Frequencies of value counts

Unique

Unique	2 ?
Unique (%)	50.0%

Histogram of lengths of the category

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Bund width (m)
Categorical

HIGH CORRELATION
MISSING

Distinct	3
Distinct (%)	75.0%
Missing	194
Missing (%)	98.0%
Memory size	1.5 KiB

3	2
30	1
1	1

Frequencies
Length

Value	Count	Frequency (%)
3	2	1.0%
30	1	0.5%
1	1	0.5%
(Missing)	194	98.0%

Frequencies of value counts

Unique

Unique	2 ?
Unique (%)	50.0%

Histogram of lengths of the category

Length

Max length	4
Median length	3
Mean length	3.005050505
Min length	3

Bund length (m)
Categorical

HIGH CORRELATION
MISSING

Distinct	3
Distinct (%)	75.0%
Missing	194
Missing (%)	98.0%
Memory size	1.5 KiB

1	2
2	1
12	1

Frequencies
Length

Value	Count	Frequency (%)
1	2	1.0%
2	1	0.5%
12	1	0.5%
(Missing)	194	98.0%

Frequencies of value counts

Unique

Unique	2 ?
Unique (%)	50.0%

Histogram of lengths of the category

Length

Max length	4
Median length	3
Mean length	3.005050505
Min length	3

Bund Material
Categorical

MISSING

Distinct	1
Distinct (%)	11.1%
Missing	189
Missing (%)	95.5%
Memory size	1.5 KiB

clay	9

Frequencies
Length

Value	Count	Frequency (%)
clay	9	4.5%
(Missing)	189	95.5%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	4
Median length	3
Mean length	3.045454545
Min length	3

Gully Block Length (m)
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	198
Missing (%)	100.0%
Memory size	1.7 KiB

Gully Block Width (m)
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	198
Missing (%)	100.0%
Memory size	1.7 KiB

Gully Block Material
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	198
Missing (%)	100.0%
Memory size	1.7 KiB

Soil Equipment or Technique Used
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	198
Missing (%)	100.0%
Memory size	1.7 KiB

Flood Efficacy
Categorical

MISSING

Distinct	3
Distinct (%)	1.9%
Missing	37
Missing (%)	18.7%
Memory size	1.5 KiB

moderate	134
high	15
low	12

Frequencies
Length

Value	Count	Frequency (%)
moderate	134	67.7%
high	15	7.6%
low	12	6.1%
(Missing)	37	18.7%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	8
Median length	8
Mean length	6.45959596
Min length	3

FR3 Area Units
Categorical

CONSTANT
REJECTED

Distinct	1
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	1.5 KiB

ha	198

Frequencies
Length

Value	Count	Frequency (%)
ha	198	100.0%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	2
Median length	2
Mean length	2
Min length	2

FR3_AreaRough
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
ZEROS

Distinct	5
Distinct (%)	62.5%
Missing	190
Missing (%)	96.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.5875
Minimum	0
Maximum	2
Zeros	3
Zeros (%)	1.5%
Memory size	1.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.1
Q3	1.125
95-th percentile	1.825
Maximum	2
Range	2
Interquartile range (IQR)	1.125

Descriptive statistics

Standard deviation	0.8025628591
Coefficient of variation (CV)	1.366064441
Kurtosis	-0.6247378549
Mean	0.5875
Median Absolute Deviation (MAD)	0.1
Skewness	1.034701614
Sum	4.7
Variance	0.6441071429
Monotocity	Not monotonic

Histogram with fixed size bins (bins=5)

Value	Count	Frequency (%)
0	3	1.5%
0.1	2	1.0%
2	1	0.5%
1.5	1	0.5%
1	1	0.5%
(Missing)	190	96.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	3	1.5%
0.1	2	1.0%
1	1	0.5%
1.5	1	0.5%
2	1	0.5%

Value	Count	Frequency (%)
2	1	0.5%
1.5	1	0.5%
1	1	0.5%
0.1	2	1.0%
0	3	1.5%

Storage Created (m3)
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
ZEROS

Distinct	39
Distinct (%)	20.0%
Missing	3
Missing (%)	1.5%
Infinite	0
Infinite (%)	0.0%

Mean	145.7128205
Minimum	0
Maximum	4154
Zeros	2
Zeros (%)	1.0%
Memory size	1.5 KiB

Quantile statistics

Minimum	0
5-th percentile	13.5
Q1	25
median	40
Q3	80
95-th percentile	633
Maximum	4154
Range	4154
Interquartile range (IQR)	55

Descriptive statistics

Standard deviation	413.5702356
Coefficient of variation (CV)	2.838255647
Kurtosis	51.81934142
Mean	145.7128205
Median Absolute Deviation (MAD)	20
Skewness	6.491987871
Sum	28414
Variance	171040.3398
Monotocity	Not monotonic

Histogram with fixed size bins (bins=39)

Value	Count	Frequency (%)
25	20	10.1%
15	20	10.1%
50	19	9.6%
40	18	9.1%
30	17	8.6%
60	13	6.6%
100	11	5.6%
20	11	5.6%
10	8	4.0%
80	7	3.5%
Other values (29)	51	25.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2	1.0%
10	8	4.0%
15	20	10.1%
20	11	5.6%
25	20	10.1%

Value	Count	Frequency (%)
4154	1	0.5%
2344	1	0.5%
2100	1	0.5%
1345	1	0.5%
1238	1	0.5%

FR3_AreaIncreasedLoss
Boolean

MISSING

Distinct	1
Distinct (%)	33.3%
Missing	195
Missing (%)	98.5%
Memory size	1.5 KiB

0	3
(Missing)	195

Common Values
Chart

Value	Count	Frequency (%)
0	3	1.5%
(Missing)	195	98.5%

Changed Flood Pathway?
Boolean

MISSING

Distinct	2
Distinct (%)	1.5%
Missing	66
Missing (%)	33.3%
Memory size	1.5 KiB

no	117
yes	15
(Missing)	66

Common Values
Chart

Value	Count	Frequency (%)
no	117	59.1%
yes	15	7.6%
(Missing)	66	33.3%

Reduced Erosion?
Boolean

MISSING

Distinct	2
Distinct (%)	4.7%
Missing	155
Missing (%)	78.3%
Memory size	1.5 KiB

no	22
yes	21
(Missing)	155

Common Values
Chart

Value	Count	Frequency (%)
no	22	11.1%
yes	21	10.6%
(Missing)	155	78.3%

Asset Condition
Categorical

MISSING

Distinct	4
Distinct (%)	2.2%
Missing	13
Missing (%)	6.6%
Memory size	1.5 KiB

good	156
moderate	25
poor	3
absent	1

Frequencies
Length

Value	Count	Frequency (%)
good	156	78.8%
moderate	25	12.6%
poor	3	1.5%
absent	1	0.5%
(Missing)	13	6.6%

Frequencies of value counts

Unique

Unique	1 ?
Unique (%)	0.5%

Histogram of lengths of the category

Length

Max length	8
Median length	4
Mean length	4.449494949
Min length	3

Date Assessed
Date

MISSING

Distinct	45
Distinct (%)	24.1%
Missing	11
Missing (%)	5.6%
Memory size	1.5 KiB

Minimum	2018-05-31 12:00:00
Maximum	2020-10-07 11:00:00

Histogram

Histogram with fixed size bins (bins=45)

Comments
Categorical

HIGH CARDINALITY
MISSING

Distinct	79
Distinct (%)	69.3%
Missing	84
Missing (%)	42.4%
Memory size	1.5 KiB

Slatted	25
Clear brash	6
Slight scouring	2
Badly silted. Low priority	2
Clear Brash	2
Other values (74)	77

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
Slatted	25	12.6%
Clear brash	6	3.0%
Slight scouring	2	1.0%
Badly silted. Low priority	2	1.0%
Clear Brash	2	1.0%
Brash build up above dam	2	1.0%
Good size	2	1.0%
Good pathway in	2	1.0%
Maintenance review due Q1 2020	1	0.5%
slight scouring	1	0.5%
Other values (69)	69	34.8%
(Missing)	84	42.4%

Frequencies of value counts

Unique

Unique	71 ?
Unique (%)	62.3%

Histogram of lengths of the category

Length

Max length	60
Median length	7
Mean length	12.58585859
Min length	3

CreationDate
Date

UNIQUE

Distinct	198
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	1.5 KiB

Minimum	2019-08-03 18:37:53
Maximum	2020-10-07 15:13:58

Histogram

Histogram with fixed size bins (bins=50)

Creator
Categorical

MISSING

Distinct	1
Distinct (%)	3.8%
Missing	172
Missing (%)	86.9%
Memory size	1.5 KiB

gsmithadmin	26

Frequencies
Length

Value	Count	Frequency (%)
gsmithadmin	26	13.1%
(Missing)	172	86.9%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	11
Median length	3
Mean length	4.050505051
Min length	3

EditDate
Date

Distinct	197
Distinct (%)	99.5%
Missing	0
Missing (%)	0.0%
Memory size	1.5 KiB

Minimum	2020-01-29 14:54:16
Maximum	2020-10-07 15:13:58

Histogram

Histogram with fixed size bins (bins=50)

Editor
Categorical

MISSING

Distinct	1
Distinct (%)	0.5%
Missing	12
Missing (%)	6.1%
Memory size	1.5 KiB

gsmithadmin	186

Frequencies
Length

Value	Count	Frequency (%)
gsmithadmin	186	93.9%
(Missing)	12	6.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	11
Median length	11
Mean length	10.51515152
Min length	3

longitude
Real number (ℝ)

HIGH CORRELATION
UNIQUE

Distinct	198
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	-1.709514809
Minimum	-1.81663
Maximum	-1.5606919
Zeros	0
Zeros (%)	0.0%
Memory size	1.5 KiB

Quantile statistics

Minimum	-1.81663
5-th percentile	-1.777469068
Q1	-1.757926072
median	-1.728301006
Q3	-1.661295013
95-th percentile	-1.571073804
Maximum	-1.5606919
Range	0.2559381
Interquartile range (IQR)	0.09663105881

Descriptive statistics

Standard deviation	0.06118858184
Coefficient of variation (CV)	-0.03579295219
Kurtosis	-0.03131510903
Mean	-1.709514809
Median Absolute Deviation (MAD)	0.0369472
Skewness	0.7978542129
Sum	-338.4839322
Variance	0.003744042547
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-1.758064559	1	0.5%
-1.770853333	1	0.5%
-1.774979703	1	0.5%
-1.656785729	1	0.5%
-1.758489443	1	0.5%
-1.777843823	1	0.5%
-1.5615099	1	0.5%
-1.716003425	1	0.5%
-1.758075588	1	0.5%
-1.634090221	1	0.5%
Other values (188)	188	94.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1.81663	1	0.5%
-1.81656	1	0.5%
-1.81053	1	0.5%
-1.79983	1	0.5%
-1.783210321	1	0.5%

Value	Count	Frequency (%)
-1.5606919	1	0.5%
-1.5612588	1	0.5%
-1.5615099	1	0.5%
-1.5617738	1	0.5%
-1.562119	1	0.5%

latitude
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	198
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	52.04383719
Minimum	51.98011
Maximum	52.07702522
Zeros	0
Zeros (%)	0.0%
Memory size	1.5 KiB

Quantile statistics

Minimum	51.98011
5-th percentile	52.01016617
Q1	52.0287023
median	52.03841892
Q3	52.06597563
95-th percentile	52.07422232
Maximum	52.07702522
Range	0.09691521539
Interquartile range (IQR)	0.0372733309

Descriptive statistics

Standard deviation	0.02117500448
Coefficient of variation (CV)	0.000406868625
Kurtosis	-0.8723273582
Mean	52.04383719
Median Absolute Deviation (MAD)	0.0138980384
Skewness	-0.1004431877
Sum	10304.67976
Variance	0.0004483808146
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
52.03816216	1	0.5%
52.06783191	1	0.5%
52.02649249	1	0.5%
52.00221321	1	0.5%
52.02291011	1	0.5%
52.02355373	1	0.5%
52.03710575	1	0.5%
52.03334614	1	0.5%
52.06034333	1	0.5%
52.03748964	1	0.5%
Other values (188)	188	94.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
51.98011	1	0.5%
52.00201133	1	0.5%
52.0020128	1	0.5%
52.00220427	1	0.5%
52.00221321	1	0.5%

Value	Count	Frequency (%)
52.07702522	1	0.5%
52.07656807	1	0.5%
52.0763655	1	0.5%
52.07602425	1	0.5%
52.07577705	1	0.5%

log10_price
Real number (ℝ)

HIGH CORRELATION

Distinct	25
Distinct (%)	12.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.811130596
Minimum	-2
Maximum	3.778151974
Zeros	0
Zeros (%)	0.0%
Memory size	1.5 KiB

Quantile statistics

Minimum	-2
5-th percentile	0.004321373783
Q1	2.000043427
median	2.000043427
Q3	2.176120211
95-th percentile	3.191493414
Maximum	3.778151974
Range	5.778151974
Interquartile range (IQR)	0.1760767838

Descriptive statistics

Standard deviation	0.9906289171
Coefficient of variation (CV)	0.5469671372
Kurtosis	2.630265293
Mean	1.811130596
Median Absolute Deviation (MAD)	0.1760767838
Skewness	-1.47733525
Sum	358.603858
Variance	0.9813456515
Monotocity	Not monotonic

Histogram with fixed size bins (bins=25)

Value	Count	Frequency (%)
2.000043427	65	32.8%
0.004321373783	30	15.2%
2.176120211	23	11.6%
2.079217436	22	11.1%
1.778223627	10	5.1%
2.361746718	9	4.5%
2.204147125	7	3.5%
2.30105171	5	2.5%
2.414990051	5	2.5%
-2	3	1.5%
Other values (15)	19	9.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-2	3	1.5%
0.004321373783	30	15.2%
1.778223627	10	5.1%
2.000043427	65	32.8%
2.079217436	22	11.1%

Value	Count	Frequency (%)
3.778151974	1	0.5%
3.602061077	1	0.5%
3.579784739	1	0.5%
3.426512888	1	0.5%
3.33344929	2	1.0%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

First rows

	ObjectID	GlobalID	Select project	FR1_ProjectName	Asset ID:	Asset Type	Asset Description	Date Installed	Installed Cost (£)	Watercourse Type	Stream Width (m)	Land Drainage Consent Difficulty	Ecological Consent Difficulty	Average member length in Leaky Barrier (m)	Wood Diameter (cm)	Height of Leaky Barrier above bed (cm)	Height of Leaky Barrier above bank (cm)	Wood Species Used	Other Wood Species	Bund height (m)	Bund width (m)	Bund length (m)	Bund Material	Gully Block Length (m)	Gully Block Width (m)	Gully Block Material	Soil Equipment or Technique Used	Flood Efficacy	FR3 Area Units	FR3_AreaRough	Storage Created (m3)	FR3_AreaIncreasedLoss	Changed Flood Pathway?	Reduced Erosion?	Asset Condition	Date Assessed	Comments	CreationDate	Creator	EditDate	Editor	longitude	latitude	log10_price
0	883	33059012-1c4d-43c7-adb7-496972f3c9b4	A017	Shipston	A017_2006151117	leaky_barriers	9	2020-06-02 11:00:00	1	ordinary	3.0	easy	n_a	5.0	20.0	30.0	0.0	willow_dead	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	moderate	ha	NaN	135.0	NaN	no	NaN	good	2020-06-15 11:00:00	NaN	2020-06-15 10:18:01	gsmithadmin	2020-08-03 11:44:52	NaN	-1.715078	52.069716	0.004321
1	1066	02b90a36-d984-4b36-a299-4fbbe884f7b2	A017	Shipston	A017_2008051630	leaky_barriers	BLOCKPOTT*1	2020-08-05 11:00:00	260	ordinary	1.5	easy	n_a	3.0	NaN	15.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	moderate	ha	NaN	40.0	NaN	no	NaN	good	2020-06-29 23:00:00	Slatted	2020-08-05 16:44:24	NaN	2020-09-18 19:01:54	gsmithadmin	-1.732871	52.026232	2.414990
2	1067	6f0e9956-8d95-4ebf-a540-9f0cabc735e9	A017	Shipston	A017_2008051627	leaky_barriers	BLOCKPOTT*2	2020-08-05 11:00:00	260	ordinary	1.5	easy	n_a	3.5	NaN	15.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	moderate	ha	NaN	30.0	NaN	no	NaN	good	2020-06-29 23:00:00	Slatted	2020-08-05 16:44:36	NaN	2020-09-18 19:02:03	gsmithadmin	-1.732574	52.026312	2.414990
3	1068	a5d7435c-363e-41bf-ac2e-cea617acbfcd	A017	Shipston	A017_2008051625	leaky_barriers	BLOCKPOTT*3	2020-08-05 11:00:00	260	ordinary	1.5	easy	n_a	3.0	NaN	15.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	moderate	ha	NaN	25.0	NaN	no	NaN	good	2020-06-29 23:00:00	Slatted	2020-08-05 16:44:49	NaN	2020-09-18 19:02:11	gsmithadmin	-1.732450	52.026399	2.414990
4	1069	01f0b340-5a4d-483d-91d0-7161b87d3ccb	A017	Shipston	A017_2008051622	leaky_barriers	BLOCKPOTT*4	2020-08-05 11:00:00	260	ordinary	2.0	easy	n_a	4.0	NaN	15.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	moderate	ha	NaN	30.0	NaN	no	NaN	good	2020-06-29 23:00:00	Slatted	2020-08-05 16:45:02	NaN	2020-09-18 19:02:50	gsmithadmin	-1.732442	52.026492	2.414990
5	1058	7b72fa58-62c9-4c1c-9617-a3fb8bf7cd83	A017	Shipston	A017_2008051617	leaky_barriers	BLOCKPOTT*5	2020-08-05 11:00:00	260	ordinary	1.0	easy	n_a	3.0	NaN	15.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	ha	NaN	25.0	NaN	no	NaN	good	2020-06-29 23:00:00	Slatted	2020-08-05 15:22:21	NaN	2020-09-18 19:02:22	gsmithadmin	-1.732281	52.026592	2.414990
6	442	1d32eb4f-29cb-4dd9-8e9c-4d94d643dc02	A017	Shipston	A017_2002241950	leaky_barriers	BLOCKPOTT01LB1	2017-10-10 12:00:00	60	ordinary	1.0	easy	n_a	2.5	10.0	5.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	low	ha	NaN	10.0	NaN	no	NaN	moderate	2020-02-15 12:00:00	Low priority	2020-02-24 20:06:31	gsmithadmin	2020-02-28 07:24:22	gsmithadmin	-1.731846	52.022910	1.778224
7	443	06539413-6f5b-4643-8dca-6e8940039a05	A017	Shipston	A017_2002242006	leaky_barriers	BLOCKPOTT02LB2	2017-10-10 12:00:00	60	ordinary	1.0	easy	n_a	2.0	10.0	15.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	low	ha	NaN	10.0	NaN	NaN	NaN	moderate	2020-02-15 12:00:00	Silted, some scouring. Low Priority	2020-02-24 20:13:57	gsmithadmin	2020-02-28 07:24:32	gsmithadmin	-1.731913	52.023080	1.778224
8	444	2e6b604a-fca5-44f1-85e1-118e97dd4afd	A017	Shipston	A017_2002242017	leaky_barriers	BLOCKPOTT03LB3	2017-10-10 12:00:00	60	ordinary	1.5	easy	n_a	2.5	15.0	0.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	low	ha	NaN	10.0	NaN	no	NaN	moderate	2020-02-15 12:00:00	Silted. Low priority	2020-02-24 20:21:28	gsmithadmin	2020-02-28 07:24:41	gsmithadmin	-1.731838	52.023261	1.778224
9	445	3824078b-cb41-40f2-8e84-469b90340bcb	A017	Shipston	A017_2002242021	leaky_barriers	BLOCKPOTT04LB4	2017-10-10 12:00:00	60	ordinary	NaN	easy	n_a	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	low	ha	NaN	10.0	NaN	no	NaN	moderate	2020-02-15 12:00:00	Badly silted. Low priority	2020-02-24 20:25:54	gsmithadmin	2020-02-28 07:24:51	gsmithadmin	-1.731857	52.023405	1.778224

Last rows

	ObjectID	GlobalID	Select project	FR1_ProjectName	Asset ID:	Asset Type	Asset Description	Date Installed	Installed Cost (£)	Watercourse Type	Stream Width (m)	Land Drainage Consent Difficulty	Ecological Consent Difficulty	Average member length in Leaky Barrier (m)	Wood Diameter (cm)	Height of Leaky Barrier above bed (cm)	Wood Species Used	Other Wood Species	Bund height (m)	Bund width (m)	Bund length (m)	Bund Material	Gully Block Length (m)	Gully Block Width (m)	Gully Block Material	Soil Equipment or Technique Used	Flood Efficacy	FR3 Area Units	FR3_AreaRough	Storage Created (m3)	FR3_AreaIncreasedLoss	Changed Flood Pathway?	Reduced Erosion?	Asset Condition	Date Assessed	Comments	CreationDate	Creator	EditDate	Editor	longitude	latitude	log10_price
188	623	0dcabf5f-35c5-468f-b796-6895259f1549	A017	Shipston	A017_2004221656	leaky_barriers	KNEELONG42LB42	2018-10-22 11:00:00	100	ordinary	1.5	easy	n_a	3.0	15.0	30.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	moderate	ha	NaN	50.0	NaN	yes	NaN	good	2020-04-21 23:00:00	Some build up behind dam	2020-04-22 16:00:44	NaN	2020-08-15 13:39:31	gsmithadmin	-1.756386	52.068120	2.000043
189	619	4a1f3841-8431-40a0-8da1-2c8b6e2a2f9f	A017	Shipston	A017_2004211150	leaky_barriers	KNEELONG43LB43	2020-04-21 11:00:00	100	ordinary	1.5	easy	n_a	3.0	15.0	60.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	moderate	ha	NaN	50.0	NaN	no	NaN	good	2020-04-21 23:00:00	NaN	2020-04-21 10:58:28	NaN	2020-08-15 13:39:42	gsmithadmin	-1.756457	52.067832	2.000043
190	618	2c130aff-9e62-4e69-a852-4b04881bc2b6	A017	Shipston	A017_2004211152	leaky_barriers	KNEELONG44LB44	2018-10-21 11:00:00	100	ordinary	1.0	easy	n_a	2.5	15.0	45.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	moderate	ha	NaN	45.0	NaN	no	NaN	good	2020-04-21 23:00:00	Rebar used	2020-04-21 10:58:11	NaN	2020-08-15 13:39:49	gsmithadmin	-1.756359	52.067583	2.000043
191	617	02a1780b-5ee0-4b98-babb-754fa2fadb00	A017	Shipston	A017_2004211155	leaky_barriers	KNEELONG45LB45	2018-10-21 11:00:00	100	ordinary	1.0	easy	n_a	2.5	15.0	45.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	moderate	ha	NaN	80.0	NaN	no	NaN	good	2020-04-21 23:00:00	NaN	2020-04-21 10:57:57	NaN	2020-08-15 13:40:00	gsmithadmin	-1.756378	52.066720	2.000043
192	629	9600a2c4-fb34-44a3-809e-99c0101bb269	A017	Shipston	A017_2004221625	leaky_barriers	KNEELONG46LB46	2018-10-22 11:00:00	100	ordinary	1.5	easy	n_a	3.0	15.0	60.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	moderate	ha	NaN	50.0	NaN	no	NaN	good	2020-04-21 23:00:00	NaN	2020-04-22 16:01:31	NaN	2020-08-15 13:40:10	gsmithadmin	-1.756140	52.066347	2.000043
193	628	01fb3d79-a96f-401e-92af-c5358ad1ec1f	A017	Shipston	A017_2004221628	leaky_barriers	KNEELONG47LB47	2020-04-22 11:00:00	100	ordinary	1.5	easy	n_a	3.5	15.0	60.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	moderate	ha	NaN	50.0	NaN	no	NaN	good	2020-04-21 23:00:00	NaN	2020-04-22 16:01:25	NaN	2020-08-15 13:40:20	gsmithadmin	-1.756129	52.066076	2.000043
194	627	224efb9a-5a7a-4f12-8ebf-3eb368459314	A017	Shipston	A017_2004221633	leaky_barriers	KNEELONG48LB48	2018-10-22 11:00:00	100	ordinary	1.5	easy	n_a	4.0	15.0	60.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	moderate	ha	NaN	60.0	NaN	no	NaN	good	2020-04-21 23:00:00	NaN	2020-04-22 16:01:20	NaN	2020-08-15 13:40:28	gsmithadmin	-1.756120	52.065675	2.000043
195	626	ce4a7b74-c608-4cd6-9d9a-fbba4bca2d53	A017	Shipston	A017_2004221636	leaky_barriers	KNEELONG49LB49	2018-10-22 11:00:00	100	ordinary	1.5	easy	n_a	3.5	15.0	45.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	moderate	ha	NaN	45.0	NaN	no	NaN	good	2020-04-21 23:00:00	NaN	2020-04-22 16:01:14	NaN	2020-08-15 13:40:37	gsmithadmin	-1.755944	52.065577	2.000043
196	625	fe9b5dee-2d45-4ee1-a16f-d3fb2d967640	A017	Shipston	A017_2004221639	leaky_barriers	KNEELONG50LB50	2020-04-22 11:00:00	100	ordinary	1.5	easy	n_a	3.0	15.0	45.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	high	ha	NaN	60.0	NaN	no	NaN	good	2020-04-22 11:00:00	Brash to be cleared	2020-04-22 16:01:06	NaN	2020-08-15 13:40:46	gsmithadmin	-1.755823	52.065232	2.000043
197	624	cb9090f8-1682-41b8-ba76-04028f57a6a9	A017	Shipston	A017_2004221644	leaky_barriers	KNEELONG51LB51	2020-04-22 11:00:00	100	ordinary	1.5	easy	n_a	3.0	15.0	45.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	moderate	ha	NaN	70.0	NaN	no	NaN	moderate	NaT	Minor repair needed. Banding, re-bedding	2020-04-22 16:00:56	NaN	2020-08-15 13:41:04	gsmithadmin	-1.756003	52.064400	2.000043

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows